UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'opiFPubB0IoBf2gFDwsJwa7qFj/CGUMRuV3JXvznJrY='
WHERE
key_id = '0ed069ebc96e3f62e3f22e174fcc70e91b5c57c2e721ea8e6786d8d35e3a9940'
AND (
token = 'opiFPubB0IoBf2gFDwsJwa7qFj/CGUMRuV3JXvznJrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)