UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rcuGGL7nCsK9Z5i6RkefVX+bU7JGcBWDadXwRH4r2fQ='
WHERE
key_id = '940e6cc9ccc930cc87513e4eafff2b08307707efe9f9dfb852b88107ce276966'
AND (
token = 'rcuGGL7nCsK9Z5i6RkefVX+bU7JGcBWDadXwRH4r2fQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)