UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B/N6ZDTw+8utdHpAQWPyzgWIn84Hzpv7g7gHU50NHGE='
WHERE
key_id = '76ab9cde1020d3a0e6d9cf49f1107e84273882ec4db63c50edea03ddf551c71d'
AND (
token = 'B/N6ZDTw+8utdHpAQWPyzgWIn84Hzpv7g7gHU50NHGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)