UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8EaX7WqyVuh9ZTJLfh5jUwFgllr7j7dPwc+zTbK+8R0='
WHERE
key_id = 'b51e7933a5aa2b83b7990d2fc2e9494b4f330353f79c7c4cbb203ba3b7e265de'
AND (
token = '8EaX7WqyVuh9ZTJLfh5jUwFgllr7j7dPwc+zTbK+8R0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)