UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JLsQnypfeTm0x+B9xa97vJmyCkHok1WgfFFpYIVtkLU='
WHERE
key_id = 'e2f8e7bf7cefdf74fe7e1e4edf31b2870f95208bc4855b4a45180021ab06bba2'
AND (
token = 'JLsQnypfeTm0x+B9xa97vJmyCkHok1WgfFFpYIVtkLU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)