UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZsV93sh6zYiI3ULokAe7fZqKYvPv7iO4UHf/qi3HF8='
WHERE
key_id = '7d96ea7d8c8b155d9edec702c9f36ae4ef0163b8ab0bd743dda429a54e46b4c2'
AND (
token = 'KZsV93sh6zYiI3ULokAe7fZqKYvPv7iO4UHf/qi3HF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)