UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7K874l4ks3M2UOOw2zCiPwb9ZLRIima6Py61R/nMbOg='
WHERE
key_id = '27c0352094e73b9bc87f4e1e0245c0333dd481bc424988282b30fb91751855c1'
AND (
token = '7K874l4ks3M2UOOw2zCiPwb9ZLRIima6Py61R/nMbOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)