UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrZDZFsaa2rdfOF1WjoCuOAxqr220ahGkdPN8kauMo4='
WHERE
key_id = 'e7f8c8f0e79545e192c02dfddc1a7b2ed96d7966e09ee26fc550434c79f03fac'
AND (
token = 'ZrZDZFsaa2rdfOF1WjoCuOAxqr220ahGkdPN8kauMo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)