UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'atZpOF/h1kVhJCFRJU1jHt9XHR3F2ahH1b73DcCwViI='
WHERE
key_id = 'c20901a5858f6cfaa562a5cbf047a9202e021a23e64ab93e9590545d517f8d6f'
AND (
token = 'atZpOF/h1kVhJCFRJU1jHt9XHR3F2ahH1b73DcCwViI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)