UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QsJoj2IveM74t5rW5oeufLeLVxCiT1IE56IuknQTKfg='
WHERE
key_id = '23d78e178b83922af3a78f76c7945e8567192e2b4e34ba1c335dc0b8b5a1258d'
AND (
token = 'QsJoj2IveM74t5rW5oeufLeLVxCiT1IE56IuknQTKfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)