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