UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y+wBufebnYan2s/RXGCgXn1RPcpmTKNTYV6F0WPNseI='
WHERE
key_id = 'b78fdf00438c9d274756e3b0595be3e0459d0555f5c742b81cb23e28d81d14ad'
AND (
token = 'Y+wBufebnYan2s/RXGCgXn1RPcpmTKNTYV6F0WPNseI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)