UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qxuf64+9ImyRCV9WZKHuOnkGiDDraIvj872nu8bELPA='
WHERE
key_id = 'e2148021c65e0c8430fcfe00173e2f4ef78188d385cd7fea66871f2a86739d8c'
AND (
token = 'qxuf64+9ImyRCV9WZKHuOnkGiDDraIvj872nu8bELPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)