UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0KNXUVrf8UfDl9ReRHZOV61eTG1fuACJ4Hl9Wd9wWOo='
WHERE
key_id = '765b5b884763b262e117b1f0d7d89e24ed83a27153060b7ca91eefb2ceef2ef6'
AND (
token = '0KNXUVrf8UfDl9ReRHZOV61eTG1fuACJ4Hl9Wd9wWOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)