UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QZnWmz3Bt/VMcJidX0C+590npuT+DxFNAarhwS9i/Y4='
WHERE
key_id = '0ef85238c3a41b8e911dd275bec41d4a6a727b7204cc5629d03427480a97ab57'
AND (
token = 'QZnWmz3Bt/VMcJidX0C+590npuT+DxFNAarhwS9i/Y4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)