UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJ7V1edU3d9GsFv70SMYHroo4wlSlBm6q+duQufOG3w='
WHERE
key_id = 'c8ae14d70448350a5a5b460817baf13aae5dbf0be7b5f8b27f30b35cca5fb595'
AND (
token = 'gJ7V1edU3d9GsFv70SMYHroo4wlSlBm6q+duQufOG3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)