UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tj2R3O2nOW0T+/eNTpM0lcK7EecVXQkuPshc40SyAgw='
WHERE
key_id = 'b9aeba71df901c55cf08403997d2a3e32badc8a37b9a5dfe45efee07f53945cd'
AND (
token = 'tj2R3O2nOW0T+/eNTpM0lcK7EecVXQkuPshc40SyAgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)