UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9Fgacq38baVqLaW1cYSoRpT2WFREwfshEzPMqKPjok='
WHERE
key_id = 'f397c93edd8078016c3eb4bea1a51e7763c9a1772d866bbf14064a9a6305a23e'
AND (
token = 'R9Fgacq38baVqLaW1cYSoRpT2WFREwfshEzPMqKPjok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)