UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idLSc5bWVohts7+8Z0nCs/3tPQ4rEDRGpdSc3vghvcw='
WHERE
key_id = 'b0e1d17506a2560cf51df46f7b28105e8e4dc36b1737d5214ef7699ec2326fda'
AND (
token = 'idLSc5bWVohts7+8Z0nCs/3tPQ4rEDRGpdSc3vghvcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)