UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5zBT9ZVSDkX+BPYnyJ8DYnfUkSVAfJ0heIZidSia/rU='
WHERE
key_id = '938fdebf265f9f75bda9a0c2137e3ed2bf0bb2ce1e6abb734e7a2dc3ea3925d6'
AND (
token = '5zBT9ZVSDkX+BPYnyJ8DYnfUkSVAfJ0heIZidSia/rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)