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