UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBcyAhgSs+QIv4Ob4J6JM8aihl9ay5ZNkyefvRtc1LA='
WHERE
key_id = 'c6d1dee71bead12af30fa10ee766f3e53c56ac54fef92d4defd102fb670aea6a'
AND (
token = 'ZBcyAhgSs+QIv4Ob4J6JM8aihl9ay5ZNkyefvRtc1LA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)