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