UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7YZQeTdRr3idgvv6yge0ckc4tPyV3YLDtKEGZLsj5QY='
WHERE
key_id = '5913663e3b6cc7dbdc2d00d0f68667f97db5f91c42e41b4cc4b02812a6eeded0'
AND (
token = '7YZQeTdRr3idgvv6yge0ckc4tPyV3YLDtKEGZLsj5QY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)