UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WbtXZ8j9R9zb8by4dDtizK0KdAdH/j+FNp3DXO7TaGs='
WHERE
key_id = 'bc074ce73cf4503aa676f43f8f58f2896695e7ccae39b8f76935e48aa98e3f2e'
AND (
token = 'WbtXZ8j9R9zb8by4dDtizK0KdAdH/j+FNp3DXO7TaGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)