UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZxVnEhuwZ867wz+PFagYkzSlv7NgswxjwBjpQBnIQFU='
WHERE
key_id = 'eb8d59d95c7720efbfaf56def5920c60efbea04360ace2dc69c9299e0f246c3b'
AND (
token = 'ZxVnEhuwZ867wz+PFagYkzSlv7NgswxjwBjpQBnIQFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)