UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LoXEUAALX7YlGNmv4Q6g1k+uqBjUIS/g3vSmNfKSgVY='
WHERE
key_id = '394dad00724739de62988f41c8d041de3a664acaaeb301445895c3b81dda1743'
AND (
token = 'LoXEUAALX7YlGNmv4Q6g1k+uqBjUIS/g3vSmNfKSgVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)