UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3OxcKTDUEFVyFV0Q6f9Mct1KtEqZc00Zqi5rcx3ichU='
WHERE
key_id = 'f30f951b2719430810885179d894122898d58bae9e7fc0770eeec4209c4a5caf'
AND (
token = '3OxcKTDUEFVyFV0Q6f9Mct1KtEqZc00Zqi5rcx3ichU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)