UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPtYBag/rSEVbxnJDL2AnZOENh4Z3nOxHmfi7L1QkPM='
WHERE
key_id = '7e734f32efac2766604527cce54011616ef80ee1778909ff4bd3e72ff7b7a087'
AND (
token = 'lPtYBag/rSEVbxnJDL2AnZOENh4Z3nOxHmfi7L1QkPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)