UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8QEDMf9wT0uuAHx4e+G8bU9To+JX3F7SHllfRyrtOM='
WHERE
key_id = '06c8b4aa576c256de75bf45013a3a3b30f39e2c7a71a4fbc052a890a68df3fc6'
AND (
token = 'H8QEDMf9wT0uuAHx4e+G8bU9To+JX3F7SHllfRyrtOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)