UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BZsdaefYFv2X83ijEnShF4ynP0VOoB3ugUXl9Osd+I='
WHERE
key_id = 'bf4b44d4e232359cb1b99efd9c224cc2e9f5f3e12bfaa66b960b96c96befadb6'
AND (
token = '0BZsdaefYFv2X83ijEnShF4ynP0VOoB3ugUXl9Osd+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)