UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'toAvbVTOSPL4VHh9QW1tO1TyfDoBkoKiL7XW8/7KpgE='
WHERE
key_id = '51b604bb15ef31b9a83eec65f91fde36e5b603015efdf0744fd7c7dda45af8b7'
AND (
token = 'toAvbVTOSPL4VHh9QW1tO1TyfDoBkoKiL7XW8/7KpgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)