UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uLg7cRLIPh1YS8u0o6yVZgn431SpYCJHT7wuCap45jc='
WHERE
key_id = '78accb1e9a5cfa83db673fabad6e06e65a08cc48412f8f4b04a3be181c4df251'
AND (
token = 'uLg7cRLIPh1YS8u0o6yVZgn431SpYCJHT7wuCap45jc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)