UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8iRYdPCKoYXX9xcLECxskG66c6UZlxLnu6rq0VhJFkI='
WHERE
key_id = 'd8041a9c1e299fc99a62a68db0a138b93052ec69e8b2bef7d8cc725afb8c2775'
AND (
token = '8iRYdPCKoYXX9xcLECxskG66c6UZlxLnu6rq0VhJFkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)